create view vDonation as
    select min(Activity.ID)                                ID,
           min(Activity.TRANSACTION_DATE)    TRANSACTION_DATE,
           min(Activity.SOURCE_CODE)               SOURCE_CODE,
           sum(Activity.AMOUNT)                        AMOUNT,
           Activity.ORIGINATING_TRANS_NUM,
           Activity.ORG_CODE,
           min(Activity.CAMPAIGN_CODE)          CAMPAIGN_CODE,
           min(Activity.SOLICITOR_ID)               SOLICITOR_ID,
           sum (Activity.TAXABLE_VALUE)          TAXABLE_VALUE,
           max(Activity.OTHER_CODE)               OTHER_CODE,   
           max(UF_1)                                           UF_1,
           max(Trans.MEM_TRIB_ID)                  MEM_TRIB_ID,
           max(Trans.MEM_TRIB_NAME_TEXT)  MEM_TRIB_NAME_TEXT     
         /*from Activity,Trans - jf - 23 mar 06*/
        from Trans LEFT OUTER JOIN Activity on Trans.ACTIVITY_SEQN = Activity.SEQN
        where Activity.ACTIVITY_TYPE in ('GIFT','PLEDGE')    
        /*and Trans.ACTIVITY_SEQN *= Activity.SEQN*/
        and Trans.TRANSACTION_TYPE = 'DIST' and Trans.JOURNAL_TYPE = 'IN'
        and Trans.SOURCE_SYSTEM = 'FR'
group by Activity.ORIGINATING_TRANS_NUM,Activity.ORG_CODE

GO
GRANT REFERENCES ON  [dbo].[vDonation] TO [IMIS]
GRANT SELECT ON  [dbo].[vDonation] TO [IMIS]
GRANT INSERT ON  [dbo].[vDonation] TO [IMIS]
GRANT DELETE ON  [dbo].[vDonation] TO [IMIS]
GRANT UPDATE ON  [dbo].[vDonation] TO [IMIS]
GO